package com.zking.frame.LYK;

import java.sql.Connection;

import java.sql.SQLException;
import java.sql.Statement;




public class InsertSeatdata {

	
public static void insertSAll( String seat_all,int user_id,int seatnumber,int scenei_id ,int price,String filmname ,String cinemaname) {
	
		Connection conn=JDBC.getConn();
	
		String sql="insert into seat values (NULL,"+user_id+","+scenei_id+", '"+seat_all+" ',"+seatnumber+","+price+",'"+filmname+"','"+cinemaname+"',0"+")";
		try {
			Statement st= conn.createStatement();
			int i=st.executeUpdate(sql);
			System.out.println(i);
			
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
}
